Example: Purchasing 3 ETH with 0.12463836 BTC. The entry in the Purchase Table would be:
Ticker: ETH
Volume: 3
Unit Price:
3 ETH = 0.12463836 BTC
3 ETH = 0.12463836 BTC x $50,814 (to convert the total price to AUD)
3 ETH = $6,347 (total price in AUD)
1 ETH = $2,115 (unit price in AUD)
The first step is finding the equivalent total purchase price in AUD. With a BTC price of $50,814 the total price of the transaction is $6,347 for 3 ETH.
The Unit Price (what the Sheet needs) refers to the price of a single ETH, so the unit price that you would enter is $6,347 / 3 = $2,115
Fees:
Continuing on the example above, find your equivalent fee (in this case priced in BTC) by converting it to your local currency.
ie. The fee is 0.0012463836 BTC. Therefore 0.0012463836 x $50,814 (BTC Price) = $63.33.