Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #755 Sep 16, 2012 www.energyefficientbuild.com.
user blahblahdrugs said: (http://productforums.google.com/forum/#!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
No comments:
Post a Comment