Offline Audio Guide Mapping Sheet

Match each number on the gallery wall to a work and the right file for each language. Use the blank sheet to catch wrong or missing file IDs before testing playback.

In short

Make one row for each stop and language you plan to offer. Copy the number from the wall label and add the work ID and approved recording ID.

Compare the approved ID with the one you find in the release list. Flag missing entries, wrong IDs, and unexpected repeats.

Download the blank mapping sheet to make the check before testing playback.

Stop 205 can lead to the right artwork and still point an English listener to the wrong recording. In our fictional Harbor Light exhibition, the English entries for stops 101 and 205 both pointed to A2. The Korean entries were already correct. The mapping sheet showed us which row to fix.

What goes in an audio guide mapping sheet?

Start with the number the visitor sees. The SFMOMA audio-stop instructions show how a number on a wall label can lead to material for an artwork. Record that number alongside your collection or exhibition ID. Harbor Light uses 101 for Glass Current (W1) and 205 for Blue Landing (W2).

Make a separate row for every planned language at each stop. In this sheet, ko means Korean and en means English. Copy the expected ID from the approved recording list and the observed ID from the release list you are checking. Write the release identifier on each row so the next reviewer can trace the result to the right version.

NOS Code and its preview of the Harbor Light sheet
Code holds the HTML for the sample sheet. Its preview shows the file IDs.

Use the completed CSV as a reference, or download the completed HTML example to see the corrected sheet in a browser. Keep the blank CSV header and add or remove rows to match your release. The artwork and file IDs in the example are fictional.

How do you find a wrong or missing file?

Read each row from stop to work to language. Check the two file IDs for that exact combination. A repeated ID can flag a copied entry. Compare it with the approved list before changing it, especially if two rows are meant to share a clip.

View showing mismatched English file for stop 205
In View, the English row for stop 205 expects B2 and points to A2.

Harbor Light release HL-01 first had three matches out of four. The English row for 205 / W2 expected B2 but listed A2, the approved English file for 101 / W1. That gave one excess reference to A2. Three divided by four gives an exact match rate of 75%. Count mapping rows in the denominator, one per planned language at each stop.

When the release list has no entry for a planned language, leave the observed ID blank and mark the row Missing. Keep it in the denominator. If the list gives a different ID from the approved one, mark it Wrong file. If the approved ID is still unknown, mark the row Unverified and resolve it before signing off. With zero planned rows, leave the rate blank.

The four mapping rows open in NOS Edit
Edit opens the existing sheet with the flagged row in place.

How do you record and recheck the fix?

Write down the affected stop, work, and language before changing the release entry. Here the correction is 205 / W2 / en: A2 to B2. The other three observed IDs stay as they were. For a real release, make the correction in the system that supplies the release list and check the resulting list again.

NOS Share panel showing the reader link and permissions
Share shows the address to send to a reviewer who only needs to read the sheet.

We opened the Harbor Light reader link while signed out. It showed the wrong file on the English row for 205. Keep the discrepancy alongside the release ID so a teammate reviewing the update knows what changed.

Signed-out reader showing a wrong file on the fourth row
The reader page names the other row that already uses A2.

We corrected the row in the same example and reopened the reader link. Four of four IDs matched (100%) and the duplicate reference count fell to zero.

NOS View showing four matches after the correction
The corrected View shows four matches and zero duplicate file references.
Original reader link showing B2 in the English row for stop 205
The original reader address now shows B2 for the English row at stop 205.

When not to do this

Use a device test to confirm playback or offline access. Download or install the intended release on each target device. Turn off Wi-Fi and cellular data, then try to open each planned stop and play its recording in the selected language. Use a copy of the sheet for each device so the mapping rate still counts each stop and language once.

In the CSV, keep the mapping result from the release list. For the same release, stop, and language, fill in the test device, network state, playback check, and what you observed. Use Offline unavailable if the stop or recording is unavailable before playback can be attempted. Use Playback failed if the recording is offered but fails to start or stops before it finishes. Use Not tested for a row you haven't tried on a device.

After a fix, repeat the same stop and language on the same device with the network off. Keep the first result and record the retest release and outcome in the retest column.

Fictional playback record. On Harbor Tablet 01, with Wi-Fi and cellular off, release HL-01 at stop 205 / W2 / en still shows a mapping match (B2 / B2). The playback check is Playback failed. The stop opened but audio did not start. The retest entry reads “HL-02 passed on the same device with Wi-Fi and cellular off.” The completed downloads show this fictional entry. The shared NOS sheet shows the file-ID check only.

For visitor-facing material, see the digital exhibit label guide for what goes beside a work and the museum exhibit guide for how visitors move between stops.

Where does NOS fit?

We opened the file in Code, checked the sheet in View and Edit, and found the reader link in Share. The same link showed the corrected mapping after we saved the change. A signed-out reader could open the sheet, while opening the editor prompted for sign-in. See NOS pricing for current plans.

Questions people ask

Should the stop number and file ID be the same?

Keep them in separate columns. The stop number is what visitors find on the label. The file ID is what you compare for that stop and language.

How do I count a missing translation?

Keep its planned language row, leave the observed file ID blank, and mark it Missing. Count it as an expected row and leave it out of the matched total.

Does a matching file ID mean the audio works offline?

A match confirms the ID in the release list. For playback evidence, open the intended release on the target device with the network disconnected.

Keep reading