VyExpenseConversion

Because while Vy's smartprice saves us money, it makes it a little bit of a pain to calculate ticket prices.

Requirements

• pdftk

Steps

Getting PDFs from Vy

1. Log into https://www.vy.no/mine-sider/mine-reiser
2. Filter by "Fullførte" (Completed).
3. Check off the receipts that are relevant, hit the download button. Will likely download as kvittering-*.pdf
4. Put downloaded files into a directory, e.g. FolderName

Run scripts to rename PDFs (optional) and get ticket price

1. Use ./rename_by_date.sh FolderName
   1. This step is technically optional, but for my own sanity I prefer having the PDF files sorted by date & time.
2. Use ./get_prices.sh FolderName - Will echo out in terminal a CSV you can paste into Google Sheets.
3. Paste into Google Sheets and use "Split text into columns": Image
   1. Alternatively find this in the "Data" dropdown menu: Image
4. For B-column, you will have to search and replace . => , for Google Sheets to understand it's NOK.
5. Then do a simple =SUM(B1:B100)

Upload and submit to Visma Expense.