AgTalk Home
AgTalk Home
Search Forums | Classifieds (42) | Skins | Language
You are logged in as a guest. ( logon | register )

I need a fertilizer blend spreadsheet
View previous thread :: View next thread
   Forums List -> Crop TalkMessage format
 
CentOH Hay
Posted 1/11/2010 21:34 (#1017769 - in reply to #1017074)
Subject: Re: I need a fertilizer blend spreadsheet



Marysville/Sunbury, Ohio
I guess I had a little too much time on my hands tonight. Made up a spread sheet that will let you determine price per unit of nutrient, price per pound of bulk product, optimum product blend (price based), and total blend cost. All you need to do is enter your desired NPK, S, and Z amounts as well as the respective prices for each product (These sections are in green). Once you've made those inputs, click on cell P22, then the data tab, then solver, lastly solve. Sounds kinda clunky, but seems to work just fine.

NOTE: You need the solver add in for excel for the spread sheet to work. If you don't have it, you can download it for free from microsoft.

Alex

Edited by CentOH Hay 1/12/2010 10:39




Attachments
----------------
Attachments optimumfertcalculatorV2.xlsx (10KB - 505 downloads)
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)