Sunday, September 16, 2012

yogi_Make Profit And Loss Calculations In Customized Currency Gold.Silver.Copper (intriguing indeed)

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #755   Sep 16, 2012

user blahblahdrugs said: (!category-topic/docs/spreadsheets/awhnle9sZh8)
Simple spread sheet calculation for a total noob
What I am trying to do is very simple but I can not understand how to make it work. I'd like to create a simple spreadsheet for a virtual auction house so I can calculate profits before buying and selling.

The currency format is Gold.Silver.Copper where 1 Silver = 100 Copper or 1 Gold = 100 Silver = 10,000 Copper
Bonus points for using this format but simple decimals would work fine.

The layout is:
Column A = Product (i.e Sandals)
Column B = What I can buy the product at (i.e 00.50.00)
Column C = What I can sell the product at (i.e 01.00.00)
Column D = Projected profit using this formula "(ColumnC - (ColumnC * 0.05)) - ColumnB = ColumnD"

When listing items to sell 5% of the sale value is taken away as a fee for using the auction house.

I recognize that using the decimal system with this currency system could complicate things so use your best judgement.

following is a solution to the problem