Profile

Cover photo
Devon Taylor
Attended West Virginia University
Lives in Berkeley Springs, WV
317 followers|85,949 views
AboutPostsCollectionsPhotosYouTube+1's

Stream

Devon Taylor

Shared publicly  - 
 
Advanced Google Sheets Funcitons
If you have been using Google Sheets for awhile, you have probably ran across the desire to pull data from one sheet into another.  This can be done using a couple of different functions like importrange and arrayformula.

Using these two functions, you can successfully pull data from one spreadsheet to another. This data doesn't even have to be static. You can for instance import Google Form results on an ongoing basis.

The article linked below provides a great overview of these to functions and some possible use cases.
Once a person gets going with spreadsheets a use case that tends to pop up pretty quickly is the need to combine data from multiple spreadsheets for some kind of analysis. In this post I will share how to combine the  arrayformula and importrange functions in Google Spreadsheets to make data from multiple spreadsheets more accessible.
3
2
Oleg Moskalensky's profile photoJames Pearson's profile photo
Add a comment...

Devon Taylor

Discussion  - 
 
Help me show the power of the G+ userbase and also help combat hunger! Please Vote for Shenandoah University, the underdog in this competition.

Students at Shenandoah University could win $5,000 to bring The Campus Kitchens Project to their school. Help us out by watching and voting for our video about why a Campus Kitchen will fill a need in our community! http://bit.ly/1E9POek
1
Add a comment...

Devon Taylor

Shared publicly  - 
 
Learn something new everyday!
 
#TipTuesday
Drag and drop in white to insert image inline. Drag and drop in gray to add image as attachment.
2
Deborah Tucci's profile photo
 
Thanks!
Add a comment...

Devon Taylor

Shared publicly  - 
 
Sites I check on a daily basis stored in onetab for easy access... http://www.one-tab.com/page/KsOKihTAS3SK7Y2PrFcBhw
1
Add a comment...

Devon Taylor

Discussion  - 
 
Unable to revert to old chat in Gmail using Chrome.  Looks like Google is making hangouts mandatory.  Anyone else having the same issue?
2
Add a comment...

Devon Taylor

Shared publicly  - 
 
Twitter has finally bit the bullet and come to realize that the majority of their users are content consumers rather than content creators / sharers. This is evident by the all-new front page found at Twitter.com. You can now search for and easily view trending topics in a variety of categories.
Using The Twitter HomePage for ConsumptionWhat's New?Twitter has finally bit the bullet and come to realize that the majority of their users are content consumers rather than content creators / shareers. This is evident by the all-new frontpage found at Twitter.com.  You can now search for and easily view trending topics in a variety of categories.Here is part of their official post found here.Starting today, when you go to the twitter.com homepa...
1
Rich Visotcky's profile photo
 
This is good stuff, Devon, and great use of the new Collections feature. :)
Add a comment...

Devon Taylor

Discussion  - 
 
Got the following error today... I am thinking that the old version of the script is causing errors with the new version?  Is there a way to remove the old version from the sheet?

Your script, formMule V6.5.3 (1/30/14), has recently failed to finish successfully. A summary of the failure(s) is shown below. 

Error Message Count
Lock timeout: another process was holding the lock for too long. (line 765, file "formMule") 14
There are too many LockService operations against the same script. 11
There are too many LockService operations against the same script. (line 765, file "formMule") 43
1
Andrew Stillman (Personal)'s profile photo
 
+Devon Taylor you delete scripts by going to the script editor (as the owner of the script, only) and finding "Delete" in the File menu.

Any reason you're not using the Add-ons version of formMule?
Add a comment...

Devon Taylor

Shared publicly  - 
 
Finally one response per user is here!
 
Introducing a few more ways to make Forms your own--shuffle questions, limit responses to one per user, generate a shortened sharing URL, and more. http://goo.gl/uwvGOc
2
Add a comment...

Devon Taylor

Shared publicly  - 
2
Add a comment...

Devon Taylor

Shared publicly  - 
1
Add a comment...

Devon Taylor

Shared publicly  - 
 
Nice Chrome extension for recording your tabs!  Going to have to play around with this one a bit for quick tutorials.
1
1
Cheridy Aduviri's profile photo
Add a comment...
Devon's Collections
People
In his circles
2,055 people
Have him in circles
317 people
Varun Malhotra's profile photo
Widyasari Putri's profile photo
Gill Wallace's profile photo
Don Silvius's profile photo
roy norris's profile photo
Maria Clark's profile photo
Kristen Swanson's profile photo
Ronald Buelow's profile photo
Lyndon Marshall's profile photo
Work
Occupation
Technology Trainer at Shenandoah University
Skills
Technology
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Currently
Berkeley Springs, WV
Previously
Stratford, Ontario, Canada - Moyers, WV - Morgantown, WV
Story
Introduction
I am the Technology Development Coordinator at Shenandoah University.  
Education
  • West Virginia University
    History, 2001 - 2007
  • Shepherd University
    Master of Arts in Teaching, 2009 - 20012
Basic Information
Gender
Male
Devon Taylor's +1's are the things they like, agree with, or want to recommend.
The Next Web
plus.google.com

The Next Web - Global Technology News, Business and Culture | http://www.thenextweb.com

Hangouts
market.android.com

Los Hangouts dan vida a las conversaciones privadas y en grupo con fotos, emojis y videollamadas gratis. Conéctate con amigos a través de co

Gmail
plus.google.com

Sharing news and tips from the Gmail team and friends

Chrome Web Store
chrome.google.com

Extensions created by Google for products like Google Search, Gmail, YouTube, Google+, Google Voice, Google Calendar and Google Drive.

Screencastify (Screen Video Recorder)
chrome.google.com

Screencastify is a simple video screen capture software for Chrome.

JAVA Advisory for Bb Learn Users
bbstudentinfo.blogspot.com

Certain features in Blackboard Learn rely on Java to work. Oracle is expected to release a client-side Java update (Java Update 7u51) on Tue

The Bb Moose Without a Name Contest is LIVE
bbstudentinfo.blogspot.com

Life as a moose is difficult, but life as a nameless Blackboard Traveling Support moose is a down-right travesty! That being said, the IC de

Attachments in Gmail, now with the power of Google Drive
gmailblog.blogspot.com

This new attachment experience is available on desktop and will be rolling out over the next week. If you're one of the more than 120 millio

Expert-Level Social Media Shortcuts Worth Knowing - Edudemic
www.edudemic.com

Do you know how to play 'snake' in YouTube? Quickly DM someone on Twitter using keys? These social media shortcuts are a great set of time-s

A new look for the Gmail app on iPad
gmailblog.blogspot.com

Posted by Carmen Wilkinson, Software Engineer Tablets are great because the large screen not only gives you a more immersive experience but

One Month of Traveling Blackboard Support
bbstudentinfo.blogspot.com

Today marks the end of the first month of Traveling Blackboard Support around Shenandoah University. From the vibrant teeming energy of Rueb

Media Tools – Google
www.google.com

Welcome to Google Media Tools. Consider this your starting point to tap into Google's suite of digital tools that can enhance newsgathering

In the Programmable World, All Our Objects Will Act as One | Gadget Lab ...
www.wired.com

We are surrounded by tiny, intelligent devices that capture data about how we live and what we do. Soon we'll be able to choreograph them to

International Space Station switches from Windows to Linux, for improved...
www.extremetech.com

The United Space Alliance, which manages the computers aboard the International Space Station in association with NASA, has announced that t

Gmail - Atomic Learning
www.atomiclearning.com

Gmail™, a Google™ approach to e-mail, is a new kind of Web mail, built on the idea that e-mail can be more intuitive, efficient, useful, and

Set up offline access - Google Drive Help
support.google.com

Internet outages and long plane rides shouldn't prevent you from working in Google Drive. Set up offline access so that the next time you're