Picture Albums Worksheet

My Story:

I bought my first digital camera in September 1999. I put my pictures on PhotoPoint.com. At the time, for picture hosting, they were the one. In December 2001 PhotoPoint abruptly shut down. Their bandwidth costs were too high.

Now I had all the pictures, but I didn't have my captions. For $25 they sold you a CD with your pictures and captions in an HTML slide show format. I used that as the basis in the spring of 2002 to write processing code in APL to create my own picture album slide shows. My first web page automation project. (Instagram started in 2010.)

The picture albums are in three portfolio locations:

The default portfolio is here. An album can either be a member of a Category, or simply be a member of a Major Group. Both are listed together in the Category Matrix. There are another 2,000 travel pictures that have not yet been added.
Park Slope Halloween Pictures: 2000-2025
Foraging Tours with Wildman Steve Brill
Not using this spreadsheet, but using the code behind it, are the plant indexes and pictures at Foraging Pictures.

The index pages can be displayed in two ways: The original is float:left. This is now only used but the camera store albums that have a lot of text. All other albums, the index pages are display:inline-block.

If a v is entered, or a v precedes a Category Code, it will be a virtual album. Instead of a pd_ picture data file, there is a list_ file which lists the virtual members.

A blank Category Code in the default portfolio is a private album and will not be listed. Likewise, a virtual only album is private. Other portfolios don't have categories, but they do have v for virtual albums.

The module with the album creating VBA Code.

You will need to scroll over a bit to see all of the spreadsheet.

picture albums worksheet

Three buttons on the worksheet ask for input. Two intialize a new album.