TO SET THE SHEET UP:

1. Make a copy of this sheet (File > Make a Copy)

2. Replace [UN] in sheet title with your site UN

3. Replace the link in the "CURRENCY LOG" cell with a link to your currency log (Your profile > Currency Logs)

1. Open Shop Purchases OR Scroll down to a shop transaction in the Currency Log- it will say "Shop Purchase" in Log- the latter may work better in mobile.

2. Hover over the "[x] [time] ago" to get a datestamp- transcribe it in that format into "DATE". (It is set to try to correct to this format, but the closer the better.)

3. Choose the relevant currency from the dropdown.

4. Type the amount spent into "Amount".

5. The sheet will automatically calculate the missed discount, and add it to your total owed for that currency! (Seen in top right)

6. Repeat for each "Shop Purchase" transaction.

1. Hit Share, then click "Change to anyone with the link", and then click "Copy link".

2. Open an Ask Questions Here Prompt on WoL (Submit > Prompt, select prompt), and place the link into the URL box.

3. In Rewards, add currency rewards equal to the amount owed shown in sheet in the "Owed" boxes.

You can delete this subsheet (SPLASH) if you no longer need it!