Update a Spreadsheet with New Prices and the Change

You can upload a spreadsheet with old prices, tell your muse the new date you want added, and get back an updated file with the new prices and the change for each row worked out.

What it does

The muse reads the layout of the file you upload, adds the new figures for the date you name, and calculates both the money change and the percentage change for each row. It keeps your original sheets as they were and adds the comparison alongside them, then returns a downloadable file with a short summary of the biggest rises and falls. This suits any list where you track the same items over time, such as prices, fees, rates, or costs you check each month. You do not need to write formulas or retype the table.

How to use it

1. Upload the spreadsheet you already keep, with the old figures in place.
2. Say which items to update, the new date to add, and that you want the money and percentage change for each row.
3. Wait for the updated file, then download it. The spreadsheet cannot always be opened in the chat itself.
4. Spot-check a few rows against the original source of the new figures before you trust the whole file.
5. Save the new file under a clear name, and keep the original as your backup.

What you need

• A Muse account
• A spreadsheet in a common format, such as Excel, with the old figures already in it
• The new figures, or a clear source the muse can read them from

What to watch for

• Check the numbers before you act on them. A figure pulled for the wrong date, or matched to the wrong row, will make the change column wrong even when the math is right.
• Look at how the muse names its sources for the new figures. If a source is missing or unclear for a row, look that one up yourself.
• Keep your original file untouched. The updated file should add to your records, not replace the only copy you have.
• Small lists are quick to check by hand. For a long list, check the first, middle, and last rows plus any row where the change looks surprisingly large. The muse prepares, you decide.