This study was done the calculation formula for calculating the below item. That is the moisture content of thesubstrates raw materials, water content of the mixed substrates; the amount of media, dry weight, amount of liquid, bulk densityin the bottle; dried materials volume, water volume, mixing ratio in a substrates mixing materials; water requirement amount,replenishment amount for water content control of the substrates and the total amount of substrates. And each was prepared inan Excel file for automatically calculated. The calculation of the Excel file will be able to take advantage for the mushroomgrowers; to make raw material costs, per bottle nutrient content and moisture content maintained throughout the year and newmedia composition. At this time we expect, while minimizing the quantity or deterioration in the daily ups and downs continuedgrowing courses throughout the year contribute to stabilizing production.