Need some Mathematical help
Posted: Fri Sep 21, 2012 2:14 am
Making a spreadsheet to show cost on making items such as kegs but I seem to have some math issues with the excel formula.
Example using to average the cost to make 1 deadly poison keg
so reg cost of 3gp
total potion in 1keg= 100
regs to make 1 potion= 8
% chance to suceed 20%
so i used
which seems pretty low on actual cost I am assuming I have something wrong with accounting for chance failure and succession if someone could enlighten me that would be great.
Example using to average the cost to make 1 deadly poison keg
so reg cost of 3gp
total potion in 1keg= 100
regs to make 1 potion= 8
% chance to suceed 20%
so i used
Code: Select all
(3gpx100x8)+ (1-.2)x(3gpx100x8)= 4320gp