Transferring Google Drive files between accounts

I have a large collection of files that are used by a nonprofit. The nonprofit now has a Google for Nonprofits account and I wanted to move the files that I own to that nonprofit account of which I’m an admin. I logged into the G4N account and created a new folder called Test. I shared that folder with my personal account.

I then logged into the personal account and navigated to a folder that contained a test file. I selected the file and clicked on “Move to”, navigated up to “Shared with me” (by clicking on the left arrow to reach the top folder level), then selecting the new folder called Test and clicked on “Move”. The test file was moved to that folder. Permission will need to be reset for the copied files.

Using Lookup with Mac Numbers

I have two tables, one with email address (Column A) and a number of other columns, and one with email address (Table 1, Column A) and zip code. I wanted to move the zip code column to the first table linked by email address. The Numbers Lookup function makes that happen:

Lookup(A,Table 1::A, Table 1::Postal Code)

Linking 2 spreadsheets based on look up value

I had two spreadsheets, one with email address and a couple of values. The other had email address and several more values. I wanted to link the two spreadsheets based on the unique email address, and copy items from one table to the other. I used Mac Numbers and entered the tables as two sheets. I used the Lookup function. In one table I created a new column. In that column cell I entered “=Lookup”, then clicked on the email address in that table, then clicked on the column in the second table where email addresses were located, then clicked on the column where zip codes were located (or other values I wanted to transfer). Then hit return and the values were transferred.

Lookup – Search for, Search where, Results.

Gene Portuesi’s Cyclopedia

I don’t remember how I developed an interest in cycling back in the early 1970’s. At one point I lived in East Lansing, Michigan and worked in nearby Lansing. Without a car and with intermittent bus service I needed a reliable way to get to work. I bought a Schwinn Varsity back when Schwinn made decent bikes. That bike was stolen but I enjoyed riding enough that I searched for a new bike. I came across a reference to a bike shop catalog published by Gene Portuesi called Cyclopedia. I pored over the drawings of bicycle parts and the articles about all things bike. I vaguely remember traveling to his shop and buying imported bikes for my wife and me.

Today I found copies of the 1974 Cyclopedia catalog that I owned on Sheldon Brown’s site. I think Gene was an early importer of quality European bikes but there is not much info on the web that I’ve found other than a few references to his bike shop in Detroit and later Caddilac, Michigan. Maybe it’s time for a wikipedia entry…

Counting text occurrences in Numbers

I wanted to summarize the data in a spreadsheet of information about use of Capital Bikeshare bikes. The data contain start and end station and several other variables. I just wanted to count the number of times a bike was checked out from a station in Fairfax County. The data are located on the Capital Bikeshare site. Currently the data are stored in zip files by month.

The data were downloaded, unzipped, and the csv file was located into Mac Numbers. Stations in Fairfax County have station numbers from 32200 to 32236. I sorted by station number, then cut an pasted this range into a new sheet. At the bottom of the data I added cells that contained just the station name. Then I used this formula in the adjacent column to count the occurrence of each station name in the data above:


Where $E$2:$E$624 is the absolute cell reference for the range of station names. A627 is the station name, a relative reference so that when the formula is copied and pasted to the next row, the next station name will be compared and counted.

Merging images with GIMP

Open GIMP and open the first image. Open another image either with Preview or GIMP, select and copy the image, then paste into GIMP. In the Layers menu the pasted image will appear as a Pasted Layer. Select that layer and click on Create a new layer in the lower left of the window (looks like a blank page with a plus sign in the upper left). The pasted layer should now be selected. Move the layer to the new position. It won’t appear beyond the limit of the old image unless it’s created as a new layer. Then under the Image menu select “Fit canvas to layers” and the second image should now appear in a new, larger canvas. Repeat for additional images.