Within Google Drive there are several useful things a person could do. I will cover some of them as I go, but today I wanted to specifically talk about the ability to Import Range. Inside Google Drive you can import part of one document into another.Let me give you an example, let's say your fundraising for a trip. You are not the only one going, there is also X, Y, and Z. You of course keep books of everything, how much money came in, how much money went out and so on and so forth. Every so often one of the people that are going as well asks you for where they are at. Now, more than likely you don't open up the financial books every single day, but only when you need to enter numbers, on top of that, you are not the only one entering numbers. Lets say you have a volunteer a parent of child X who is helping my keeping track of a certain fund raiser for you, and there is also someone else who helps as well, they all have numbers. We could periodically get all of those numbers together when a good opportunity arises (remember their volunteers, they are volunteers with busy lives) and then place them all onto a central sheet and then take those and split those into separate sheets for each individual (X, Y, and Z) and so on and so forth. And to think, this is only two volunteers and three other participants, imagine if we start increasing the numbers.
Obviously, one of the uses of password protected, cloud based documents would be to simplify the primary problem of having multiple people enter numbers. However, this still would leave us with the problem of getting the individual account balances and so on. Import Range is one way to solve this secondary problem. In a Google Drive Document you can create and individual document (spreadsheet) and tell it to import information from another. So you can set up an individual spreadsheet for X, Y, and Z and then tell it to take only that information that would apply to them. Of course you could then share that file with that person and they could see their balance information virtually anytime it was updated.
This example is of course only one use, you could also do this with a grade book, in my example dealing with page level permissions in a website, this is exactly what I was doing, I simply embedded the individual student document inside the webpage.
Enough talk, here is how you do it with a Google Drive Spreadsheet:
Create two spreadsheets, enter the information you want into one. On the other, in the cell block you want the information to appear (or start to appear if you are importing multiple cells,) you type:
=ImportRange("KEY*," "sheet#**! cell info***")
* Your key is the documents number. Every Google doc has one, as you look at your document link (web address) you will see this, "key=**********************#gid=0" all of the *'s here represent your, "key." This tells Google which document your are after.
** As with most spreadsheets, you can have multiple sheets, Google here needs to know which one you are looking at, if you don't make any change
s it will simply be, "sheet 1" however, you can name each sheet whatever you want, make sure to make appropriate changes.
*** The cell info is what cells you want to import is it B3-B10 or B3:B10 or something else, either way, Google needs to know.
In the end it should look something like this:
(I have made changes to the key number, so this will not legitimately work.)
=ImportRange("0AtDRdV2hTfzqdHlCUjVoZUlpVBTEgDMzbnlobUlsZmc", "Sheet1!A3:A11")
No comments:
Post a Comment