Reston Golf Course Redevelopments

Hidden Creek Country Club in north Reston.

Reston National Golf Course in south Reston.

Washington Post article about possible development of Reston National Golf Course: ‘But this case is about more than a golf course. The Metro is coming to Reston, and lots of large development decisions are coming down the pike there. How will Reston’s master plan, using concentrated density to create green space elsewhere, fit with those who would build the next Ballston around Reston’s stations at Wiehle Avenue and Reston Parkway?

Reston’s creator, Robert E. Simon, told me recently [see below] that it fits fine, so long as you still have the recreation.’

Robert Simon to the Washington Post in 2012: ‘He said density was not a bad thing. “Density is good,” Simon said. ”It makes open space possible,” when you use apartments or high-rises to create density vertically. “High-rises are not anti-community,” he said, and he noted that the Stratford apartment complex near Reston Town Center has a community of engaged residents that is “really fabulous.”’

Create an iMovie from photos

In iMovie, under All Projects, Create New, Movie (vs. Trailer).

Under Preferences, set Photo Placement (Fit), Photo Duration (0.5s), Transitions (0.5s).

Under My Movie, Import Media and select all of the photos to be included.

Drag photos in sequence to the timeline at the bottom.

To save the movie, File>Share>File…

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:

=COUNTIF($E$2:$E$624,A627)

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.