Excel Spreadsheet for Website Code Processing: Dashboards

The spreadsheet has a Dashboard page with links and buttons that manage each site. Those dashboards are below. Some of the sites have a page on processing that site. More will be added.

The other worksheet tabs for processing:

Find and Replace with Numerous Options
Various Images Utilities
Slide show creators:
- Picture Albums Management - The first that was automated. Creates all files, including the indexes. Data is stored centrally in one folder.
- Add Navigation Code to Folder - Gets the page order from the parent page (usually the folder's index file). Optionally creates all htm files that are not folders that are part of the navigation. Data is stored in each folder.
- Slide Shows Management Sheet - Inserts a thumbnail index into the index page. Data is stored in each folder.
Site Map Building Sheet
Various Site Analysis Utilities
Maintenance Utilities

The spreadsheet has numerous functions and sub routines for fast web page creation from images and data. A discussion of file reading and saving.

The spreadsheet is available on request, if you are proficient in HTML 5 and VBA.

The below dashboards are in the order they were written or converted to Excel VBA.

J. Wiss & Sons Co.
My premiere site on the Wiss family and its scissors company.

dashboard 1 wiss

Jamaica Hotel History
My collection of hotel information, brochures, photos, postcards and clippings organized into a site.
This site has a page on site building.

dashboard 2 jamaica

Tunbridge Ware
My collection of 19th century treen made in the Tunbridge Wells area of England.

dashboard 3 tunbridge

Floor Borders
My collection of pictures taken of parquet floor borders in Brooklyn. They date to the late 19th century and early 20th century.
This site has some processing notes.

dashboard 4 floor borders

BigSpud
Newsgroup discussions on potatoes collected, edited and organized.

dashboard 5 bigspud

Foraging Pictures
All the pictures I took on foraging walks collected by plant.
This site has a page on site processing.

dashboard 6 foraging

Greenport Walking Tour
Has click/touch sensitive map with audio playback. Optimized for mobile devices.

dashboard 7 walk tour

Paleofood
This started with recipes posted to my PaleoFood mailing list, and it grew from there. The recipes are organized like a cookbook.
This site has a page on processing.

dashboard 8 paleofood

Vintage Auto Ads
This is mostly built based on the file names the macro finds in the images folder.

dashboard 9 vintage auto ads

Elyse Taylor Art
This is a slide show engine that is used twice here. All are members of the primary slide show(s).
Then optionally, there are an unlimited number of subset slide shows.
Database: 1-Filename, 2-Image Name, 3-Primary Page, 4-Opt. Page(s), 5-Dimensions/Index, 5-Painting/Slide Title, 6-Opt. Page Text
Image naming follows my usual convention: Full-size has a -f suffix. Web-size has no suffix. Thumbnail has a -tn suffix.
Image reduction: Web-size: 800x800 at 80% compression. Thumbnails: 320x320 at 75% compression.
The VBA Module

dashboard 10 art