Thank you for helping proofread this spreadsheet. This project began as part of my effort to encourage adoption and engagement with The Valley Pocket Harmonist (VPH). I wanted to create a practical resource for singers who enjoy studying from spreadsheets or use databases to help compile minutes from singings. In addition, this database will help prepare the tunebook for inclusion on websites like Hymnary.org, where it can be connected with other hymn texts and tunes—making it easier for others to discover and study.

HERE IS THE DATABASE:

https://docs.google.com/spreadsheets/d/1gFpGYjOmstKUHCjYIoIfV3g73TSu2grnuzSY9QBjYts/edit?usp=sharing

Project Status

At this stage, about 98% of the foundational documentation is complete. Nearly all tunes in the book have their basic information filled in. But the next state is making sure it is 100% complete and correct.

Spreadsheet Overview

Each row in the spreadsheet represents one tune. The columns include:

  • Order: The strict sequential order in which the tune appears in the book.
  • Call: The number that would be announced at a singing (page number plus position, if needed).
  • Title / Time / Key / Meter / Text Author / Composer, etc.: These should be self-explanatory.
  • The “first lines” have many elements that are correct for the score, but not correct for listing as a first line of poetry. Please remove any dashes or hyphens, or spaces left from words stretched over multiple notes.

Your Role as a Proofreader

The first column, labeled “PROOF”, is where we ask for your input. We need each element in every row to be carefully double-checked. Errors—whether human or digital—can creep in anywhere, so your careful attention is vital before this data is made public.

What to Do:

  1. Go through each row (tune) one at a time.
  2. Compare the spreadsheet data against the tunebook to verify:
    • Page number and tune title
    • Text and music attribution
    • Key, meter, time signature
    • First line of text, remove any hyphens/dashes.
    • Any other included details
  3. If everything in the row checks out, mark it with an “X” in the PROOF column. This indicates it’s been checked and confirmed.
  4. If you find an error or uncertainty, feel free to:
    • Correct it if you’re confident,
    • Or flag it with an exclamation mark (e.g., “!”) in the PROOF column instead of “X”.

This is an ongoing collaborative effort. The project cannot move forward until the proofreading stage is complete. Thank you for contributing to the accuracy and future usability of this resource!