# 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](https://i.alex.lol/2023-08-31_mMjHWK.png)
   1. Alternatively find this in the "Data" dropdown menu: [Image](https://i.alex.lol/2023-12-14_nnslWj.png)
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.  
![STONKS](https://i.alex.lol/2023-12-14_sSrzzs.png)