Example: Purchasing 3 ETH with 0.12463836 BTC. The entry in the Purchase Table would be:
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
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.